package com.bw.gmallapi.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;
import java.util.Map;

@Mapper
public interface ProductMapper {
    @Select("select sum(order_amount) from sku_2203A where toYYYYMMDD(stt)=#{date}")
    BigDecimal selectAllGmv(Integer date);


}
